Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Null Conditions

A `NULL` condition tests for nulls. This is the only condition that you should use to test for nulls.

null_conditions::=

Description of the illustration null_conditions.gif

Table 7-10 lists the null conditions.

Table 7-10 Null Conditions ``

Type of Condition | Operation | Example
--- | --- | ---
    IS [NOT] NULL
| Tests for nulls. See Also: "Nulls" |
    SELECT last_name
      FROM employees
      WHERE commission_pct
      IS NULL;